Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	37076
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	5.1 MiB
Average record size in memory	144.0 B

Variable types

Numeric	10
Categorical	8

Alerts

`Attempted` is highly overall correlated with `Full`	High correlation
`NumberOfMajors` is highly overall correlated with `NumberOfUniqueMajors`	High correlation
`NumberOfUniqueMajors` is highly overall correlated with `NumberOfMajors`	High correlation
`Full` is highly overall correlated with `Attempted`	High correlation
`Ethnicity` is highly overall correlated with `IsHispanic`	High correlation
`IsHispanic` is highly overall correlated with `Ethnicity`	High correlation
`Dev` is highly imbalanced (79.0%)	Imbalance
`Ethnicity` is highly imbalanced (54.6%)	Imbalance
`IsHispanic` is highly imbalanced (59.3%)	Imbalance
`Internet` has 15832 (42.7%) zeros	Zeros
`PercentageOfRepeats` has 30558 (82.4%) zeros	Zeros
`PercentageOfHistDrop` has 25109 (67.7%) zeros	Zeros
`CumGPALast` has 602 (1.6%) zeros	Zeros
`PercentageOfAbsence` has 30482 (82.2%) zeros	Zeros

Reproduction

Analysis started	2023-09-01 17:49:52.075004
Analysis finished	2023-09-01 17:50:10.712586
Duration	18.64 seconds
Software version	pandas-profiling v0.0.dev0
Download configuration	config.json

StudentID
Real number (ℝ)

Distinct	14352
Distinct (%)	38.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.5670171 × 10⁹

Minimum	1.0100064 × 10⁸
Maximum	1.0112756 × 10¹⁰
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	289.8 KiB

Quantile statistics

Minimum	1.0100064 × 10⁸
5-th percentile	1.970071 × 10⁸
Q1	5.8000927 × 10⁸
median	1.0111108 × 10¹⁰
Q3	1.0112361 × 10¹⁰
95-th percentile	1.0112742 × 10¹⁰
Maximum	1.0112756 × 10¹⁰
Range	1.0011756 × 10¹⁰
Interquartile range (IQR)	9.532352 × 10⁹

Descriptive statistics

Standard deviation	4.654677 × 10⁹
Coefficient of variation (CV)	0.70879625
Kurtosis	-1.6908924
Mean	6.5670171 × 10⁹
Median Absolute Deviation (MAD)	1626782.5
Skewness	-0.55315131
Sum	2.4347872 × 10¹⁴
Variance	2.1666018 × 10¹⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
712001867	13	< 0.1%
1.011110826 × 10¹⁰	12	< 0.1%
1.011110491 × 10¹⁰	12	< 0.1%
1.011110424 × 10¹⁰	12	< 0.1%
502003442	12	< 0.1%
761004119	12	< 0.1%
403009141	11	< 0.1%
114008764	11	< 0.1%
273002269	11	< 0.1%
434007061	11	< 0.1%
Other values (14342)	36959	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
101000642	1	< 0.1%
101001184	6	< 0.1%
101003030	4	< 0.1%
101004016	2	< 0.1%
101008593	1	< 0.1%
101008781	1	< 0.1%
101009897	5	< 0.1%
102001082	1	< 0.1%
102002426	3	< 0.1%
102002757	5	< 0.1%

Value	Count	Frequency (%)
1.011275622 × 10¹⁰	1	< 0.1%
1.011275618 × 10¹⁰	1	< 0.1%
1.011275521 × 10¹⁰	1	< 0.1%
1.011275481 × 10¹⁰	1	< 0.1%
1.011275473 × 10¹⁰	1	< 0.1%
1.011275472 × 10¹⁰	1	< 0.1%
1.01127547 × 10¹⁰	1	< 0.1%
1.011275448 × 10¹⁰	1	< 0.1%
1.011275446 × 10¹⁰	1	< 0.1%
1.011275443 × 10¹⁰	1	< 0.1%

Attempted
Real number (ℝ)

Distinct	27
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.2913205

Minimum	1
Maximum	29
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	289.8 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	6
median	9
Q3	12
95-th percentile	16
Maximum	29
Range	28
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.1207612
Coefficient of variation (CV)	0.44350652
Kurtosis	-0.51622739
Mean	9.2913205
Median Absolute Deviation (MAD)	3
Skewness	0.29269749
Sum	344485
Variance	16.980673
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
6	5653	15.2%
12	4267	11.5%
3	3797	10.2%
9	3710	10.0%
8	3426	9.2%
13	3414	9.2%
10	2103	5.7%
7	2054	5.5%
4	1791	4.8%
15	1561	4.2%
Other values (17)	5300	14.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	32	0.1%
2	82	0.2%
3	3797	10.2%
4	1791	4.8%
5	197	0.5%
6	5653	15.2%
7	2054	5.5%
8	3426	9.2%
9	3710	10.0%
10	2103	5.7%

Value	Count	Frequency (%)
29	2	< 0.1%
26	1	< 0.1%
25	8	< 0.1%
24	6	< 0.1%
23	27	0.1%
22	35	0.1%
21	74	0.2%
20	82	0.2%
19	388	1.0%
18	312	0.8%

Full
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	289.8 KiB

0	25015
1	12061

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	37076
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	0
5th row	1

Common Values

Value	Count	Frequency (%)
0	25015	67.5%
1	12061	32.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	25015	67.5%
1	12061	32.5%

Most occurring characters

Value	Count	Frequency (%)
0	25015	67.5%
1	12061	32.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	37076	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	25015	67.5%
1	12061	32.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	37076	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	25015	67.5%
1	12061	32.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	37076	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	25015	67.5%
1	12061	32.5%

Age
Real number (ℝ)

Distinct	60
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.41833

Minimum	14
Maximum	73
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	289.8 KiB

Quantile statistics

Minimum	14
5-th percentile	17
Q1	19
median	21
Q3	27
95-th percentile	44
Maximum	73
Range	59
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	8.8026535
Coefficient of variation (CV)	0.36049367
Kurtosis	3.362206
Mean	24.41833
Median Absolute Deviation (MAD)	3
Skewness	1.8482997
Sum	905334
Variance	77.486708
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19	5017	13.5%
18	4532	12.2%
20	4396	11.9%
21	3125	8.4%
17	2868	7.7%
22	1984	5.4%
23	1526	4.1%
24	1179	3.2%
25	987	2.7%
26	907	2.4%
Other values (50)	10555	28.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
14	3	< 0.1%
15	175	0.5%
16	600	1.6%
17	2868	7.7%
18	4532	12.2%
19	5017	13.5%
20	4396	11.9%
21	3125	8.4%
22	1984	5.4%
23	1526	4.1%

Value	Count	Frequency (%)
73	2	< 0.1%
72	4	< 0.1%
71	3	< 0.1%
70	4	< 0.1%
69	2	< 0.1%
68	6	< 0.1%
67	9	< 0.1%
66	6	< 0.1%
65	13	< 0.1%
64	16	< 0.1%

Dev
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	289.8 KiB

0	34448
1	2192
2	401
3	35

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	37076
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	34448	92.9%
1	2192	5.9%
2	401	1.1%
3	35	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	34448	92.9%
1	2192	5.9%
2	401	1.1%
3	35	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	34448	92.9%
1	2192	5.9%
2	401	1.1%
3	35	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	37076	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	34448	92.9%
1	2192	5.9%
2	401	1.1%
3	35	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	37076	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	34448	92.9%
1	2192	5.9%
2	401	1.1%
3	35	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	37076	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	34448	92.9%
1	2192	5.9%
2	401	1.1%
3	35	0.1%

Internet
Real number (ℝ)

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.3446704

Minimum	0
Maximum	9
Zeros	15832
Zeros (%)	42.7%
Negative	0
Negative (%)	0.0%
Memory size	289.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	4
Maximum	9
Range	9
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.5564579
Coefficient of variation (CV)	1.1575014
Kurtosis	0.48912431
Mean	1.3446704
Median Absolute Deviation (MAD)	1
Skewness	1.0962863
Sum	49855
Variance	2.4225612
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	15832	42.7%
1	7448	20.1%
2	5863	15.8%
3	3434	9.3%
4	2768	7.5%
5	1216	3.3%
6	396	1.1%
7	103	0.3%
8	14	< 0.1%
9	2	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	15832	42.7%
1	7448	20.1%
2	5863	15.8%
3	3434	9.3%
4	2768	7.5%
5	1216	3.3%
6	396	1.1%
7	103	0.3%
8	14	< 0.1%
9	2	< 0.1%

Value	Count	Frequency (%)
9	2	< 0.1%
8	14	< 0.1%
7	103	0.3%
6	396	1.1%
5	1216	3.3%
4	2768	7.5%
3	3434	9.3%
2	5863	15.8%
1	7448	20.1%
0	15832	42.7%

PercentageOfRepeats
Real number (ℝ)

Distinct	38
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.096953554

Minimum	0
Maximum	1
Zeros	30558
Zeros (%)	82.4%
Negative	0
Negative (%)	0.0%
Memory size	289.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.75
Maximum	1
Range	1
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.24431757
Coefficient of variation (CV)	2.5199444
Kurtosis	6.2010217
Mean	0.096953554
Median Absolute Deviation (MAD)	0
Skewness	2.6710229
Sum	3594.65
Variance	0.059691073
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
0	30558	82.4%
1	1550	4.2%
0.5	1053	2.8%
0.25	788	2.1%
0.3333333333	694	1.9%
0.2	559	1.5%
0.6666666667	461	1.2%
0.4	373	1.0%
0.1666666667	233	0.6%
0.75	193	0.5%
Other values (28)	614	1.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	30558	82.4%
0.09090909091	1	< 0.1%
0.1	1	< 0.1%
0.1111111111	3	< 0.1%
0.125	18	< 0.1%
0.1428571429	62	0.2%
0.1666666667	233	0.6%
0.2	559	1.5%
0.2222222222	10	< 0.1%
0.25	788	2.1%

Value	Count	Frequency (%)
1	1550	4.2%
0.9090909091	2	< 0.1%
0.9	1	< 0.1%
0.8888888889	6	< 0.1%
0.875	7	< 0.1%
0.8571428571	18	< 0.1%
0.8333333333	32	0.1%
0.8	96	0.3%
0.7777777778	3	< 0.1%
0.75	193	0.5%

PercentageOfHistDrop
Real number (ℝ)

Distinct	360
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.05996983

Minimum	0
Maximum	1
Zeros	25109
Zeros (%)	67.7%
Negative	0
Negative (%)	0.0%
Memory size	289.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.076923077
95-th percentile	0.3
Maximum	1
Range	1
Interquartile range (IQR)	0.076923077

Descriptive statistics

Standard deviation	0.12968569
Coefficient of variation (CV)	2.1625156
Kurtosis	18.63201
Mean	0.05996983
Median Absolute Deviation (MAD)	0
Skewness	3.7062475
Sum	2223.4414
Variance	0.016818379
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	25109	67.7%
0.2	591	1.6%
0.25	523	1.4%
0.1666666667	477	1.3%
0.125	430	1.2%
0.1428571429	427	1.2%
0.1111111111	403	1.1%
0.3333333333	399	1.1%
0.1	379	1.0%
0.5	348	0.9%
Other values (350)	7990	21.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	25109	67.7%
0.01333333333	1	< 0.1%
0.01428571429	1	< 0.1%
0.01515151515	1	< 0.1%
0.01754385965	2	< 0.1%
0.01818181818	3	< 0.1%
0.01886792453	1	< 0.1%
0.01923076923	3	< 0.1%
0.01960784314	1	< 0.1%
0.02	4	< 0.1%

Value	Count	Frequency (%)
1	221	0.6%
0.8571428571	1	< 0.1%
0.8461538462	1	< 0.1%
0.8333333333	4	< 0.1%
0.8	12	< 0.1%
0.75	19	0.1%
0.7272727273	1	< 0.1%
0.7142857143	7	< 0.1%
0.7	1	< 0.1%
0.6875	1	< 0.1%

TermCode
Categorical

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	289.8 KiB

B17C	3436
B20C	3342
B18C	3336
B19C	3124
B22C	3030
Other values (9)	20808

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	148304
Distinct characters	10
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	B17C
2nd row	B17C
3rd row	B18Q
4th row	B20Q
5th row	B21Q

Common Values

Value	Count	Frequency (%)
B17C	3436	9.3%
B20C	3342	9.0%
B18C	3336	9.0%
B19C	3124	8.4%
B22C	3030	8.2%
B23C	2985	8.1%
B21C	2809	7.6%
B17Q	2708	7.3%
B18Q	2506	6.8%
B19Q	2463	6.6%
Other values (4)	7337	19.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
b17c	3436	9.3%
b20c	3342	9.0%
b18c	3336	9.0%
b19c	3124	8.4%
b22c	3030	8.2%
b23c	2985	8.1%
b21c	2809	7.6%
b17q	2708	7.3%
b18q	2506	6.8%
b19q	2463	6.6%
Other values (4)	7337	19.8%

Most occurring characters

Value	Count	Frequency (%)
B	37076	25.0%
2	23464	15.8%
1	22548	15.2%
C	22062	14.9%
Q	15014	10.1%
7	6144	4.1%
8	5842	3.9%
0	5680	3.8%
9	5587	3.8%
3	4887	3.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	74152	50.0%
Decimal Number	74152	50.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	23464	31.6%
1	22548	30.4%
7	6144	8.3%
8	5842	7.9%
0	5680	7.7%
9	5587	7.5%
3	4887	6.6%

Uppercase Letter

Value	Count	Frequency (%)
B	37076	50.0%
C	22062	29.8%
Q	15014	20.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	74152	50.0%
Common	74152	50.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	23464	31.6%
1	22548	30.4%
7	6144	8.3%
8	5842	7.9%
0	5680	7.7%
9	5587	7.5%
3	4887	6.6%

Latin

Value	Count	Frequency (%)
B	37076	50.0%
C	22062	29.8%
Q	15014	20.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	148304	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
B	37076	25.0%
2	23464	15.8%
1	22548	15.2%
C	22062	14.9%
Q	15014	10.1%
7	6144	4.1%
8	5842	3.9%
0	5680	3.8%
9	5587	3.8%
3	4887	3.3%

MajorChangedFromLast
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	289.8 KiB

0	31704
1	5372

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	37076
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
0	31704	85.5%
1	5372	14.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	31704	85.5%
1	5372	14.5%

Most occurring characters

Value	Count	Frequency (%)
0	31704	85.5%
1	5372	14.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	37076	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	31704	85.5%
1	5372	14.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	37076	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	31704	85.5%
1	5372	14.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	37076	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	31704	85.5%
1	5372	14.5%

NumberOfMajors
Real number (ℝ)

Distinct	30
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.9280127

Minimum	1
Maximum	36
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	289.8 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	3
median	5
Q3	8
95-th percentile	13
Maximum	36
Range	35
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.5113643
Coefficient of variation (CV)	0.59233414
Kurtosis	2.1119313
Mean	5.9280127
Median Absolute Deviation (MAD)	2
Skewness	1.2665267
Sum	219787
Variance	12.329679
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
4	5827	15.7%
2	5332	14.4%
5	4621	12.5%
3	4335	11.7%
6	3518	9.5%
7	3224	8.7%
8	2520	6.8%
9	1781	4.8%
10	1603	4.3%
11	1169	3.2%
Other values (20)	3146	8.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	297	0.8%
2	5332	14.4%
3	4335	11.7%
4	5827	15.7%
5	4621	12.5%
6	3518	9.5%
7	3224	8.7%
8	2520	6.8%
9	1781	4.8%
10	1603	4.3%

Value	Count	Frequency (%)
36	1	< 0.1%
34	1	< 0.1%
28	1	< 0.1%
27	3	< 0.1%
26	5	< 0.1%
25	5	< 0.1%
24	7	< 0.1%
23	10	< 0.1%
22	19	0.1%
21	30	0.1%

NumberOfUniqueMajors
Real number (ℝ)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.603652

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	289.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	3
Maximum	7
Range	6
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.78204162
Coefficient of variation (CV)	0.48766293
Kurtosis	1.8685097
Mean	1.603652
Median Absolute Deviation (MAD)	0
Skewness	1.3241148
Sum	59457
Variance	0.61158909
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	20339	54.9%
2	12158	32.8%
3	3676	9.9%
4	770	2.1%
5	106	0.3%
6	25	0.1%
7	2	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	20339	54.9%
2	12158	32.8%
3	3676	9.9%
4	770	2.1%
5	106	0.3%
6	25	0.1%
7	2	< 0.1%

Value	Count	Frequency (%)
7	2	< 0.1%
6	25	0.1%
5	106	0.3%
4	770	2.1%
3	3676	9.9%
2	12158	32.8%
1	20339	54.9%

CumGPALast
Real number (ℝ)

Distinct	5072
Distinct (%)	13.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.951954

Minimum	0
Maximum	4
Zeros	602
Zeros (%)	1.6%
Negative	0
Negative (%)	0.0%
Memory size	289.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1.3
Q1	2.5
median	3.0513
Q3	3.598575
95-th percentile	4
Maximum	4
Range	4
Interquartile range (IQR)	1.098575

Descriptive statistics

Standard deviation	0.86017982
Coefficient of variation (CV)	0.29139336
Kurtosis	1.4421768
Mean	2.951954
Median Absolute Deviation (MAD)	0.5513
Skewness	-1.1287391
Sum	109446.65
Variance	0.73990932
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	4514	12.2%
3	2611	7.0%
3.5	1193	3.2%
2	1185	3.2%
2.5	755	2.0%
0	602	1.6%
3.25	443	1.2%
3.75	374	1.0%
3.6667	346	0.9%
3.3333	340	0.9%
Other values (5062)	24713	66.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	602	1.6%
0.0667	1	< 0.1%
0.0702	1	< 0.1%
0.087	1	< 0.1%
0.1071	1	< 0.1%
0.1364	2	< 0.1%
0.1429	5	< 0.1%
0.15	1	< 0.1%
0.1538	2	< 0.1%
0.1579	2	< 0.1%

Value	Count	Frequency (%)
4	4514	12.2%
3.9897	1	< 0.1%
3.9804	1	< 0.1%
3.9701	1	< 0.1%
3.9677	1	< 0.1%
3.9672	1	< 0.1%
3.9671	1	< 0.1%
3.9634	1	< 0.1%
3.962	1	< 0.1%
3.9615	1	< 0.1%

PercentageOfAbsence
Real number (ℝ)

Distinct	77
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.073110454

Minimum	0
Maximum	1
Zeros	30482
Zeros (%)	82.2%
Negative	0
Negative (%)	0.0%
Memory size	289.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.5
Maximum	1
Range	1
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.19455806
Coefficient of variation (CV)	2.6611524
Kurtosis	10.430473
Mean	0.073110454
Median Absolute Deviation (MAD)	0
Skewness	3.1967747
Sum	2710.6432
Variance	0.037852838
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	30482	82.2%
0.5	940	2.5%
0.3333333333	890	2.4%
1	765	2.1%
0.25	698	1.9%
0.2	533	1.4%
0.1666666667	401	1.1%
0.1428571429	307	0.8%
0.6666666667	233	0.6%
0.4	229	0.6%
Other values (67)	1598	4.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	30482	82.2%
0.05555555556	2	< 0.1%
0.05882352941	2	< 0.1%
0.0625	6	< 0.1%
0.06666666667	7	< 0.1%
0.07142857143	9	< 0.1%
0.07692307692	21	0.1%
0.08333333333	32	0.1%
0.09090909091	58	0.2%
0.1	87	0.2%

Value	Count	Frequency (%)
1	765	2.1%
0.9285714286	1	< 0.1%
0.9166666667	1	< 0.1%
0.9	1	< 0.1%
0.8888888889	5	< 0.1%
0.875	8	< 0.1%
0.8571428571	16	< 0.1%
0.8461538462	1	< 0.1%
0.8333333333	25	0.1%
0.8125	1	< 0.1%

Ethnicity
Categorical

HIGH CORRELATION IMBALANCE

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	289.8 KiB

White, Non-Hispanic	25651
Hispanic	5499
Black, Non-Hispanic	2920
American Indian or Alaskan Native	1650
Asian	726
Other values (5)	630

Length

Max length	35
Median length	19
Mean length	17.679604
Min length	5

Characters and Unicode

Total characters	655489
Distinct characters	32
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	White, Non-Hispanic
2nd row	White, Non-Hispanic
3rd row	White, Non-Hispanic
4th row	White, Non-Hispanic
5th row	White, Non-Hispanic

Common Values

Value	Count	Frequency (%)
White, Non-Hispanic	25651	69.2%
Hispanic	5499	14.8%
Black, Non-Hispanic	2920	7.9%
American Indian or Alaskan Native	1650	4.5%
Asian	726	2.0%
International	188	0.5%
unknown	185	0.5%
Unknown or Not Reported	174	0.5%
Native Hawaiian or Pacific Islander	77	0.2%
Not Hispanic or Latino	6	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
non-hispanic	28571	39.1%
white	25651	35.1%
hispanic	5505	7.5%
black	2920	4.0%
or	1907	2.6%
native	1727	2.4%
american	1650	2.3%
indian	1650	2.3%
alaskan	1650	2.3%
asian	726	1.0%
Other values (8)	1138	1.6%

Most occurring characters

Value	Count	Frequency (%)
i	100058	15.3%
n	71774	10.9%
a	46816	7.1%
c	38800	5.9%
s	36529	5.6%
	36019	5.5%
p	34250	5.2%
H	34153	5.2%
o	31385	4.8%
N	30478	4.6%
Other values (22)	195227	29.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	462754	70.6%
Uppercase Letter	99574	15.2%
Space Separator	36019	5.5%
Dash Punctuation	28571	4.4%
Other Punctuation	28571	4.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	100058	21.6%
n	71774	15.5%
a	46816	10.1%
c	38800	8.4%
s	36529	7.9%
p	34250	7.4%
o	31385	6.8%
e	29641	6.4%
t	28114	6.1%
h	25651	5.5%
Other values (9)	19736	4.3%

Uppercase Letter

Value	Count	Frequency (%)
H	34153	34.3%
N	30478	30.6%
W	25651	25.8%
A	4026	4.0%
B	2920	2.9%
I	1915	1.9%
U	174	0.2%
R	174	0.2%
P	77	0.1%
L	6	< 0.1%

Space Separator

Value	Count	Frequency (%)
	36019	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	28571	100.0%

Other Punctuation

Value	Count	Frequency (%)
,	28571	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	562328	85.8%
Common	93161	14.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	100058	17.8%
n	71774	12.8%
a	46816	8.3%
c	38800	6.9%
s	36529	6.5%
p	34250	6.1%
H	34153	6.1%
o	31385	5.6%
N	30478	5.4%
e	29641	5.3%
Other values (19)	108444	19.3%

Common

Value	Count	Frequency (%)
	36019	38.7%
-	28571	30.7%
,	28571	30.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	655489	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	100058	15.3%
n	71774	10.9%
a	46816	7.1%
c	38800	5.9%
s	36529	5.6%
	36019	5.5%
p	34250	5.2%
H	34153	5.2%
o	31385	4.8%
N	30478	4.6%
Other values (22)	195227	29.8%

Gender
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	289.8 KiB

Female	23357
Male	13674
unknown	45

Length

Max length	7
Median length	6
Mean length	5.2635937
Min length	4

Characters and Unicode

Total characters	195153
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Female
2nd row	Female
3rd row	Female
4th row	Female
5th row	Female

Common Values

Value	Count	Frequency (%)
Female	23357	63.0%
Male	13674	36.9%
unknown	45	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
female	23357	63.0%
male	13674	36.9%
unknown	45	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	60388	30.9%
a	37031	19.0%
l	37031	19.0%
F	23357	12.0%
m	23357	12.0%
M	13674	7.0%
n	135	0.1%
u	45	< 0.1%
k	45	< 0.1%
o	45	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	158122	81.0%
Uppercase Letter	37031	19.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	60388	38.2%
a	37031	23.4%
l	37031	23.4%
m	23357	14.8%
n	135	0.1%
u	45	< 0.1%
k	45	< 0.1%
o	45	< 0.1%
w	45	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
F	23357	63.1%
M	13674	36.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	195153	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	60388	30.9%
a	37031	19.0%
l	37031	19.0%
F	23357	12.0%
m	23357	12.0%
M	13674	7.0%
n	135	0.1%
u	45	< 0.1%
k	45	< 0.1%
o	45	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	195153	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	60388	30.9%
a	37031	19.0%
l	37031	19.0%
F	23357	12.0%
m	23357	12.0%
M	13674	7.0%
n	135	0.1%
u	45	< 0.1%
k	45	< 0.1%
o	45	< 0.1%

IsHispanic
Categorical

HIGH CORRELATION IMBALANCE

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	289.8 KiB

No	31370
Yes	5561
unknown	145

Length

Max length	7
Median length	2
Mean length	2.1695436
Min length	2

Characters and Unicode

Total characters	80438
Distinct characters	9
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No
2nd row	No
3rd row	No
4th row	No
5th row	No

Common Values

Value	Count	Frequency (%)
No	31370	84.6%
Yes	5561	15.0%
unknown	145	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	31370	84.6%
yes	5561	15.0%
unknown	145	0.4%

Most occurring characters

Value	Count	Frequency (%)
o	31515	39.2%
N	31370	39.0%
Y	5561	6.9%
e	5561	6.9%
s	5561	6.9%
n	435	0.5%
u	145	0.2%
k	145	0.2%
w	145	0.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	43507	54.1%
Uppercase Letter	36931	45.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	31515	72.4%
e	5561	12.8%
s	5561	12.8%
n	435	1.0%
u	145	0.3%
k	145	0.3%
w	145	0.3%

Uppercase Letter

Value	Count	Frequency (%)
N	31370	84.9%
Y	5561	15.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	80438	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	31515	39.2%
N	31370	39.0%
Y	5561	6.9%
e	5561	6.9%
s	5561	6.9%
n	435	0.5%
u	145	0.2%
k	145	0.2%
w	145	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	80438	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	31515	39.2%
N	31370	39.0%
Y	5561	6.9%
e	5561	6.9%
s	5561	6.9%
n	435	0.5%
u	145	0.2%
k	145	0.2%
w	145	0.2%

Target
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	289.8 KiB

0	32172
1	4904

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	37076
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	32172	86.8%
1	4904	13.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	32172	86.8%
1	4904	13.2%

Most occurring characters

Value	Count	Frequency (%)
0	32172	86.8%
1	4904	13.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	37076	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	32172	86.8%
1	4904	13.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	37076	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	32172	86.8%
1	4904	13.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	37076	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	32172	86.8%
1	4904	13.2%

Auto

Heatmap
Table

	StudentID	Attempted	Age	Internet	PercentageOfRepeats	PercentageOfHistDrop	NumberOfMajors	NumberOfUniqueMajors	CumGPALast	PercentageOfAbsence	Full	Dev	TermCode	MajorChangedFromLast	Ethnicity	Gender	IsHispanic	Target
StudentID	1.000	-0.070	-0.465	0.061	-0.149	-0.256	-0.258	-0.167	0.137	0.045	0.014	0.003	0.408	0.099	0.071	0.076	0.051	0.004
Attempted	-0.070	1.000	0.163	0.384	0.064	0.049	0.126	0.162	-0.033	0.029	0.775	0.105	0.066	0.108	0.036	0.042	0.028	0.135
Age	-0.465	0.163	1.000	-0.005	0.165	0.265	0.377	0.340	-0.132	0.006	0.143	0.033	0.028	0.107	0.074	0.084	0.091	0.054
Internet	0.061	0.384	-0.005	1.000	0.072	0.062	0.088	0.063	-0.021	0.068	0.401	0.042	0.077	0.048	0.016	0.031	0.016	0.138
PercentageOfRepeats	-0.149	0.064	0.165	0.072	1.000	0.324	0.140	0.062	-0.342	0.123	0.219	0.134	0.036	0.041	0.027	0.006	0.028	0.129
PercentageOfHistDrop	-0.256	0.049	0.265	0.062	0.324	1.000	0.287	0.219	-0.276	0.075	0.021	0.076	0.025	0.085	0.017	0.006	0.008	0.117
NumberOfMajors	-0.258	0.126	0.377	0.088	0.140	0.287	1.000	0.517	-0.058	-0.006	0.119	0.055	0.104	0.079	0.022	0.065	0.033	0.040
NumberOfUniqueMajors	-0.167	0.162	0.340	0.063	0.062	0.219	0.517	1.000	-0.108	0.006	0.124	0.022	0.117	0.458	0.026	0.040	0.023	0.021
CumGPALast	0.137	-0.033	-0.132	-0.021	-0.342	-0.276	-0.058	-0.108	1.000	-0.189	0.055	0.172	0.029	0.103	0.055	0.054	0.046	0.146
PercentageOfAbsence	0.045	0.029	0.006	0.068	0.123	0.075	-0.006	0.006	-0.189	1.000	0.109	0.065	0.046	0.009	0.023	0.047	0.012	0.122
Full	0.014	0.775	0.143	0.401	0.219	0.021	0.119	0.124	0.055	0.109	1.000	0.071	0.087	0.072	0.078	0.024	0.021	0.166
Dev	0.003	0.105	0.033	0.042	0.134	0.076	0.055	0.022	0.172	0.065	0.071	1.000	0.056	0.059	0.053	0.000	0.014	0.104
TermCode	0.408	0.066	0.028	0.077	0.036	0.025	0.104	0.117	0.029	0.046	0.087	0.056	1.000	0.122	0.035	0.049	0.052	0.109
MajorChangedFromLast	0.099	0.108	0.107	0.048	0.041	0.085	0.079	0.458	0.103	0.009	0.072	0.059	0.122	1.000	0.019	0.017	0.012	0.041
Ethnicity	0.071	0.036	0.074	0.016	0.027	0.017	0.022	0.026	0.055	0.023	0.078	0.053	0.035	0.019	1.000	0.104	0.695	0.030
Gender	0.076	0.042	0.084	0.031	0.006	0.006	0.065	0.040	0.054	0.047	0.024	0.000	0.049	0.017	0.104	1.000	0.006	0.011
IsHispanic	0.051	0.028	0.091	0.016	0.028	0.008	0.033	0.023	0.046	0.012	0.021	0.014	0.052	0.012	0.695	0.006	1.000	0.007
Target	0.004	0.135	0.054	0.138	0.129	0.117	0.040	0.021	0.146	0.122	0.166	0.104	0.109	0.041	0.030	0.011	0.007	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	StudentID	Attempted	Full	Age	Dev	Internet	PercentageOfRepeats	PercentageOfHistDrop	TermCode	MajorChangedFromLast	NumberOfMajors	NumberOfUniqueMajors	CumGPALast	PercentageOfAbsence	Ethnicity	Gender	IsHispanic
0	101000642	6.0	0	26.0	0	2	0.00	0.142857	B17C	0	5	1	1.6857	0.000000	White, Non-Hispanic	Female	No
1	101001184	16.0	1	27.0	0	0	0.25	0.000000	B17C	0	3	1	2.6000	0.000000	White, Non-Hispanic	Female	No
2	101001184	10.0	0	28.0	1	0	0.00	0.000000	B18Q	1	5	2	2.4286	0.000000	White, Non-Hispanic	Female	No
3	101001184	6.0	0	30.0	0	2	0.00	0.000000	B20Q	1	7	3	2.1346	0.000000	White, Non-Hispanic	Female	No
4	101001184	12.0	1	31.0	0	0	0.00	0.000000	B21Q	0	10	3	1.9138	0.000000	White, Non-Hispanic	Female	No
5	101001184	6.0	0	32.0	0	1	0.00	0.000000	B22Q	1	13	4	2.1000	1.000000	White, Non-Hispanic	Female	No
6	101001184	3.0	0	33.0	0	0	0.00	0.000000	B23C	1	14	5	2.1711	0.333333	White, Non-Hispanic	Female	No
7	101009897	8.0	0	20.0	0	0	0.00	0.000000	B17C	0	4	1	3.6970	0.000000	White, Non-Hispanic	Female	No
8	101009897	8.0	0	20.0	0	0	1.00	0.000000	B17Q	0	6	1	3.2683	0.000000	White, Non-Hispanic	Female	No
9	101009897	7.0	0	21.0	0	1	0.80	0.000000	B18Q	0	9	1	3.4634	0.000000	White, Non-Hispanic	Female	No

	StudentID	Attempted	Full	Age	Dev	Internet	PercentageOfRepeats	PercentageOfHistDrop	TermCode	NumberOfMajors	NumberOfUniqueMajors	CumGPALast	PercentageOfAbsence	Ethnicity	Gender	IsHispanic
37066	10112754429	11.0	1	22.0	0	4	0.000000	0.25	B23Q	3	1	3.2857	0.0	Black, Non-Hispanic	Male	No
37067	10112754465	9.0	1	21.0	0	1	0.666667	0.00	B23Q	3	1	0.7500	0.5	Asian	Female	No
37068	10112754483	8.0	0	20.0	1	1	0.000000	0.00	B23Q	3	1	4.0000	0.0	White, Non-Hispanic	Male	No
37069	10112754700	4.0	0	36.0	0	0	1.000000	0.25	B23Q	3	1	0.6667	0.5	White, Non-Hispanic	Female	No
37070	10112754720	7.0	0	25.0	0	0	0.333333	0.00	B23Q	3	1	0.0000	0.0	White, Non-Hispanic	Female	No
37071	10112754731	9.0	1	34.0	0	2	0.333333	0.25	B23Q	3	1	2.0000	0.5	Hispanic	Male	Yes
37072	10112754814	4.0	0	31.0	0	0	0.000000	0.00	B23Q	3	1	4.0000	0.0	American Indian or Alaskan Native	Female	No
37073	10112755207	4.0	0	23.0	0	0	0.000000	0.00	B23Q	3	1	3.2000	0.0	Hispanic	Male	Yes
37074	10112756177	12.0	1	26.0	0	1	0.000000	0.00	B23Q	3	1	3.6250	0.0	American Indian or Alaskan Native	Female	No
37075	10112756221	4.0	0	17.0	0	0	0.000000	0.00	B23Q	3	1	3.0769	0.0	Hispanic	Male	Yes

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Dash Punctuation

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter